package com.siwei.mes.mapper;

import com.siwei.mes.common.base.BaseMapper;
import com.siwei.mes.entity.ShxhSynchronizedata;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 对应上海协会上传数据表(ShxhSynchronizedata)表数据库访问层
 *
 * @author dmwang
 * @since 2024-06-29 20:33:48
 */
public interface ShxhSynchronizedataMapper extends BaseMapper<ShxhSynchronizedata> {
    /**
     * 获取所有
     *
     * @param entity
     * @return
     */
    List<ShxhSynchronizedata> getList(ShxhSynchronizedata entity);

    /**
     * 根据id获取
     *
     * @param id
     * @return
     */
    ShxhSynchronizedata loadById(@Param("id") Long id);

    /**
     * 根据试验台账id查询
     *
     * @param experimentId 试验台账id
     * @return
     */
    List<ShxhSynchronizedata> selectByExperimentId(@Param("experimentId") Long experimentId);

    ShxhSynchronizedata selectByExperimentIdOne(@Param("experimentId") Long experimentId);

    /**
     * 根据协会委托编号查询
     *
     * @param consignId 协会委托编号
     * @return
     */
    ShxhSynchronizedata selectByConsignId(@Param("consignId") String consignId);


    int countByConsignId(@Param("consignId") String consignId);
}
